/*
 * To change this template, choose Tools | Templates
 * and open the template in the editor.
 */
package ngramassigment.database;

import java.util.Arrays;
import java.util.List;

/**
 *
 * @author Tran
 */
public class DatabaseConfig {

    public static final String TB_VOCA_NAME = "VOCABULARY";
    public static final String TB_VOCA_FIELD_ID = "ID_VOCA";
    public static final String TB_VOCA_FIELD_WORD = "WORD_VOCA";
    public static final String TB_VOCA_FIELD_COUNT = "COUNT_VOCA";
    public static final String TB_VOCA_FIELD_PROB = "PROB_VOCA";
    public static String SQL_CREATE_TABLE_VOCA = "CREATE TABLE " + TB_VOCA_NAME
            + "(" + TB_VOCA_FIELD_ID + "    INT PRIMARY KEY     NOT NULL,"
            + TB_VOCA_FIELD_WORD + "        CHAR(50)    NOT NULL, "
            + TB_VOCA_FIELD_COUNT + "       INT     , "
            + TB_VOCA_FIELD_PROB + "        REAL)";
    
    public static final String TB_BIGR_NAME = "BI_GRAM";
    public static final String TB_BIGR_FIELD_ID = "ID_BIGR";
    public static final String TB_BIGR_FIELD_COUNT = "COUNT_BIGR";
    public static final String TB_BIGR_FIELD_PROB = "PROB_BIGR";
    public static String SQL_CREATE_TABLE_BI_GRAM = "CREATE TABLE " + TB_BIGR_NAME
            + "(" + TB_BIGR_FIELD_ID + "    INT PRIMARY KEY     NOT NULL,"
            + TB_BIGR_FIELD_COUNT + "       INT     , "
            + TB_BIGR_FIELD_PROB + "        REAL)";
    public static final String TB_TRIGR_NAME = "TRI_GRAM";
    public static final String TB_TRIGR_FIELD_ID = "ID_TRIGR";
    public static final String TB_TRIGR_FIELD_COUNT = "COUNT_TRIGR";
    public static final String TB_TRIGR_FIELD_PROB = "PROB_TRIGR";
    public static String SQL_CREATE_TABLE_TRI_GRAM = "CREATE TABLE " + TB_TRIGR_NAME
            + "(" + TB_TRIGR_FIELD_ID + "    REAL PRIMARY KEY     NOT NULL,"
            + TB_TRIGR_FIELD_COUNT + "       INT     , "
            + TB_TRIGR_FIELD_PROB + "        REAL)";
    
    public static final String TB_TETGR_NAME = "TET_GRAM";
    public static final String TB_TETGR_FIELD_ID = "ID_TETGR";
    public static final String TB_TETGR_FIELD_COUNT = "COUNT_TETGR";
    public static final String TB_TETGR_FIELD_PROB = "PROB_TETGR";
    public static String SQL_CREATE_TABLE_TET_GRAM = "CREATE TABLE " + TB_TETGR_NAME
            + "(" + TB_TETGR_FIELD_ID + "    REAL PRIMARY KEY     NOT NULL,"
            + TB_TETGR_FIELD_COUNT + "       INT     , "
            + TB_TETGR_FIELD_PROB + "        REAL)";
    public static final String TB_PENGR_NAME = "PEN_GRAM";
    public static final String TB_PENGR_FIELD_ID = "ID_PENGR";
    public static final String TB_PENGR_FIELD_COUNT = "COUNT_PENGR";
    public static final String TB_PENGR_FIELD_PROB = "PROB_PENGR";
    public static String SQL_CREATE_TABLE_PEN_GRAM = "CREATE TABLE " + TB_PENGR_NAME
            + "(" + TB_PENGR_FIELD_ID + "    REAL PRIMARY KEY     NOT NULL,"
            + TB_PENGR_FIELD_COUNT + "       INT     , "
            + TB_PENGR_FIELD_PROB + "        REAL)";
    
    public static final List<String> LIST_TB_NAME = Arrays.asList(TB_BIGR_NAME, TB_TRIGR_NAME, TB_TETGR_NAME
                                                                    , TB_PENGR_NAME);
    public static final List<String> LIST_TB_FIELD_ID = Arrays.asList(TB_BIGR_FIELD_ID, TB_TRIGR_FIELD_ID,
                                                                TB_TETGR_FIELD_ID, TB_PENGR_FIELD_ID);
    public static final List<String> LIST_TB_FIELD_COUNT = Arrays.asList(TB_BIGR_FIELD_COUNT, TB_TRIGR_FIELD_COUNT,
                                                                TB_TETGR_FIELD_COUNT, TB_PENGR_FIELD_COUNT);
    
}
